@echo off

set USERNAME=root
set /P PASSWORD="Enter your ROOT password here: "

mysql -u%USERNAME% -p%PASSWORD% < createTechStormSchema.sql
echo "Create TechStorm schema successfully."

mysql -u%USERNAME% -p%PASSWORD% techstorm < importTechStormDB.sql
echo "Import columns and data of techstorm schema successfully."

echo "Import Successfully!"
pause;